<?php

namespace App\DataTables\Admin;

use App\Models\BookingRide;
use Illuminate\Database\Eloquent\Builder as QueryBuilder;
use Yajra\DataTables\EloquentDataTable;
use Yajra\DataTables\Html\Builder as HtmlBuilder;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Html\Column;
use Yajra\DataTables\Html\Editor\Editor;
use Yajra\DataTables\Html\Editor\Fields;
use Yajra\DataTables\Services\DataTable;

class BookingRidesDataTable extends DataTable
{
    public function dataTable(QueryBuilder $query): EloquentDataTable
    {
        return (new EloquentDataTable($query))
            ->addIndexColumn()
            // ->editColumn('booking_code', function ($row) {
            //     if ($row->booking) {
            //         $url = route('booking.view', encrypt($row->booking->id)); // apna route lagao
            //         return '<a href="' . $url . '">' . $row->booking->booking_code . '</a>';
            //     }
            // })
            ->addColumn('no_of_passengers', function ($row) {
                if (!empty($row->booking->no_of_passengers)) {
                    return $row->booking->no_of_passengers ?? '-';
                }
                return '-';
            })
            ->addColumn('ride_type', function ($row) {
                if (!empty($row->booking->ride_type)) {
                    return $row->booking->ride_type_name ?? '-';
                }
                return '-';
            })
            ->addColumn('vehicle_type', function ($row) {
                if (!empty($row->trip->vehicleType)) {
                    return $row->trip->vehicleType?->name ?? '-';
                }
                return '-';
            })
            ->addColumn('ride_date', function ($row) {
                return !empty($row->ride_date)
                    ? \Carbon\Carbon::parse($row->ride_date)->format('M d, Y') // Aug 25, 2025
                    : '-';
            })
            ->addColumn('pickup_time', function ($row) {
                if (!empty($row->pickup_time)) {
                    return date('h:i A', strtotime($row->pickup_time));
                }
                return '-';
            })
            ->addColumn('pickup_location', function ($row) {
                return $row->locations['pickup_location'] ?? '-';
            })
            ->addColumn('drop_location', function ($row) {
                return $row->locations['drop_location'] ?? '-';
            })
            ->addColumn('fare', function ($row) {
                if (isset($row)) {
                    return '₹ ' . number_format($row->fare, 2);
                }
                return null;
            })
            ->addColumn('vehicle', function ($row) {
                if (isset($row->vehicle)) {
                    return $row->vehicle->registration_number;
                }
                return 'Not Assigned';
            })
            ->addColumn('driver', function ($row) {
                if (isset($row->driver)) {
                    return $row->driver->name;
                }
                return 'Not Assigned';
            })
            ->addColumn('status', function ($row) {
                switch ($row->status) {
                    case 0:
                        return '<span class="badge badge-warning text-white" style="font-size: medium">Pending</span>';
                    case 1:
                        return '<span class="badge badge-dark text-white" style="font-size: medium">Assigned</span>';
                    case 2:
                        return '<span class="badge badge-info text-white" style="font-size: medium">Ongoing</span>';
                    case 3:
                        return '<span class="badge badge-success text-white" style="font-size: medium">Completed</span>';
                    case 4:
                        return '<span class="badge badge-primary text-white" style="font-size: medium">Cancelled</span>';
                    default:
                        return '<span class="badge badge-secondary text-white" style="font-size: medium">Unknown</span>';
                }
            })
            ->addColumn('created_at', function ($row) {
                return date('d-m-Y', strtotime($row->created_at));
            })
            ->addColumn('action', function ($row) {
                $buttons = '<div class="table-actions d-flex gap-1">';

                // View Button
                $buttons .= '
                    <a href="' . route('admin.rides.view', encrypt($row->id)) . '" 
                    class="btn btn-primary btn-sm" title="View">
                        <i class="fa fa-eye"></i>
                    </a>';
                $buttons .= '</div>';
                return $buttons;
            })
            
            ->rawColumns(['status', 'action'])
            ->setRowId('id');
    }

    /**
     * Get the query source of dataTable.
     *
     * @return QueryBuilder<BookingRide>
     */
    public function query(BookingRide $model): QueryBuilder
    {
        $query = $model->newQuery()
            ->with(['booking', 'driver', 'vehicle','trip'])
            ->where('booking_id', $this->bookingId); 

        if (request()->filled('status')) {
            $query->where('status', request('status'));
        }
        return $query->orderBy('ride_date', 'asc')
            ->orderBy('pickup_time', 'asc');
    }


    /**
     * Optional method if you want to use the html builder.
     */
    public function html(): HtmlBuilder
    {
        return $this->builder()
            ->setTableId('bookingrides-table')
            ->setTableAttribute('class', 'table table-striped table-bordered dt-responsive nowrap jambo_table bulk_action')
            ->columns($this->getColumns())
            ->minifiedAjax(route('admin.booking.rides', $this->bookingId))
            ->orderBy(1)
            ->selectStyleSingle()
            ->responsive(true)
            ->autoWidth(false)
            ->searching(false)
            ->buttons([
                // Button::make('excel'),
                // Button::make('csv'),
                // Button::make('pdf'),
                // Button::make('print'),
                // Button::make('reset'),
                // Button::make('reload')
            ]);
    }

    /**
     * Get the dataTable columns definition.
     */
    protected function getColumns(): array
    {
        return [
            // Column::make('DT_RowIndex')->title('S.No')->orderable(false)->searchable(false),
            // Column::make('booking_code')->title('Booking ID')->addClass('all'),
            Column::make('ride_type')->title('Ride Type')->addClass('all'),
            Column::make('vehicle_type')->title('Vehicle Type')->addClass('all'),
            Column::make('ride_date')->title('Ride Date'),
            Column::make('pickup_time')->title('Pickup Time'),
            Column::make('pickup_location')->title('Pickup Location'),
            Column::make('drop_location')->title('Drop Location'),
            Column::make('distance_km')->title('Distance (km)')->addClass('none'),
            Column::make('fare')->title('Total Fare'),
            Column::make('no_of_passengers')->title('Passenger')->addClass('none'),
            Column::make('vehicle')->title('Vehicle')->searchable(true)->addClass('none'),
            Column::make('driver')->title('Driver')->searchable(true)->addClass('none'),
            Column::make('status')->title('Status')->addClass('all'),
            Column::computed('action')
                ->exportable(false)
                ->printable(false)
                ->width(120)
                ->addClass('text-center all'),
        ];
    }

    /**
     * Get the filename for export.
     */
    protected function filename(): string
    {
        return 'BookingRides_' . date('YmdHis');
    }
}